package com.cn.springcloudshop.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class YmShopOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected Integer offset = null;

    protected Integer limit = null;

    protected List<Criteria> oredCriteria;

    public YmShopOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Integer getOffset() {
        return offset;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andShopOrderIdIsNull() {
            addCriterion("shop_order_id is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdIsNotNull() {
            addCriterion("shop_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdEqualTo(Long value) {
            addCriterion("shop_order_id =", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdNotEqualTo(Long value) {
            addCriterion("shop_order_id <>", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdGreaterThan(Long value) {
            addCriterion("shop_order_id >", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdGreaterThanOrEqualTo(Long value) {
            addCriterion("shop_order_id >=", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdLessThan(Long value) {
            addCriterion("shop_order_id <", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdLessThanOrEqualTo(Long value) {
            addCriterion("shop_order_id <=", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdIn(List<Long> values) {
            addCriterion("shop_order_id in", values, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdNotIn(List<Long> values) {
            addCriterion("shop_order_id not in", values, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdBetween(Long value1, Long value2) {
            addCriterion("shop_order_id between", value1, value2, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdNotBetween(Long value1, Long value2) {
            addCriterion("shop_order_id not between", value1, value2, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoIsNull() {
            addCriterion("shop_order_flowNo is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoIsNotNull() {
            addCriterion("shop_order_flowNo is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoEqualTo(String value) {
            addCriterion("shop_order_flowNo =", value, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoNotEqualTo(String value) {
            addCriterion("shop_order_flowNo <>", value, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoGreaterThan(String value) {
            addCriterion("shop_order_flowNo >", value, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_flowNo >=", value, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoLessThan(String value) {
            addCriterion("shop_order_flowNo <", value, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoLessThanOrEqualTo(String value) {
            addCriterion("shop_order_flowNo <=", value, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoLike(String value) {
            addCriterion("shop_order_flowNo like", value, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoNotLike(String value) {
            addCriterion("shop_order_flowNo not like", value, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoIn(List<String> values) {
            addCriterion("shop_order_flowNo in", values, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoNotIn(List<String> values) {
            addCriterion("shop_order_flowNo not in", values, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoBetween(String value1, String value2) {
            addCriterion("shop_order_flowNo between", value1, value2, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderFlownoNotBetween(String value1, String value2) {
            addCriterion("shop_order_flowNo not between", value1, value2, "shopOrderFlowno");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeIsNull() {
            addCriterion("shop_order_time is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeIsNotNull() {
            addCriterion("shop_order_time is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeEqualTo(Date value) {
            addCriterion("shop_order_time =", value, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeNotEqualTo(Date value) {
            addCriterion("shop_order_time <>", value, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeGreaterThan(Date value) {
            addCriterion("shop_order_time >", value, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("shop_order_time >=", value, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeLessThan(Date value) {
            addCriterion("shop_order_time <", value, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeLessThanOrEqualTo(Date value) {
            addCriterion("shop_order_time <=", value, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeIn(List<Date> values) {
            addCriterion("shop_order_time in", values, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeNotIn(List<Date> values) {
            addCriterion("shop_order_time not in", values, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeBetween(Date value1, Date value2) {
            addCriterion("shop_order_time between", value1, value2, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderTimeNotBetween(Date value1, Date value2) {
            addCriterion("shop_order_time not between", value1, value2, "shopOrderTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberIsNull() {
            addCriterion("shop_order_waybill_number is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberIsNotNull() {
            addCriterion("shop_order_waybill_number is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberEqualTo(String value) {
            addCriterion("shop_order_waybill_number =", value, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberNotEqualTo(String value) {
            addCriterion("shop_order_waybill_number <>", value, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberGreaterThan(String value) {
            addCriterion("shop_order_waybill_number >", value, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_waybill_number >=", value, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberLessThan(String value) {
            addCriterion("shop_order_waybill_number <", value, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberLessThanOrEqualTo(String value) {
            addCriterion("shop_order_waybill_number <=", value, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberLike(String value) {
            addCriterion("shop_order_waybill_number like", value, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberNotLike(String value) {
            addCriterion("shop_order_waybill_number not like", value, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberIn(List<String> values) {
            addCriterion("shop_order_waybill_number in", values, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberNotIn(List<String> values) {
            addCriterion("shop_order_waybill_number not in", values, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberBetween(String value1, String value2) {
            addCriterion("shop_order_waybill_number between", value1, value2, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderWaybillNumberNotBetween(String value1, String value2) {
            addCriterion("shop_order_waybill_number not between", value1, value2, "shopOrderWaybillNumber");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyIsNull() {
            addCriterion("shop_order_company is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyIsNotNull() {
            addCriterion("shop_order_company is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyEqualTo(String value) {
            addCriterion("shop_order_company =", value, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyNotEqualTo(String value) {
            addCriterion("shop_order_company <>", value, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyGreaterThan(String value) {
            addCriterion("shop_order_company >", value, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_company >=", value, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyLessThan(String value) {
            addCriterion("shop_order_company <", value, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyLessThanOrEqualTo(String value) {
            addCriterion("shop_order_company <=", value, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyLike(String value) {
            addCriterion("shop_order_company like", value, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyNotLike(String value) {
            addCriterion("shop_order_company not like", value, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyIn(List<String> values) {
            addCriterion("shop_order_company in", values, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyNotIn(List<String> values) {
            addCriterion("shop_order_company not in", values, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyBetween(String value1, String value2) {
            addCriterion("shop_order_company between", value1, value2, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderCompanyNotBetween(String value1, String value2) {
            addCriterion("shop_order_company not between", value1, value2, "shopOrderCompany");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostIsNull() {
            addCriterion("shop_order_totalCost is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostIsNotNull() {
            addCriterion("shop_order_totalCost is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostEqualTo(Long value) {
            addCriterion("shop_order_totalCost =", value, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostNotEqualTo(Long value) {
            addCriterion("shop_order_totalCost <>", value, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostGreaterThan(Long value) {
            addCriterion("shop_order_totalCost >", value, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostGreaterThanOrEqualTo(Long value) {
            addCriterion("shop_order_totalCost >=", value, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostLessThan(Long value) {
            addCriterion("shop_order_totalCost <", value, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostLessThanOrEqualTo(Long value) {
            addCriterion("shop_order_totalCost <=", value, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostIn(List<Long> values) {
            addCriterion("shop_order_totalCost in", values, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostNotIn(List<Long> values) {
            addCriterion("shop_order_totalCost not in", values, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostBetween(Long value1, Long value2) {
            addCriterion("shop_order_totalCost between", value1, value2, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalcostNotBetween(Long value1, Long value2) {
            addCriterion("shop_order_totalCost not between", value1, value2, "shopOrderTotalcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostIsNull() {
            addCriterion("shop_order_productCost is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostIsNotNull() {
            addCriterion("shop_order_productCost is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostEqualTo(Long value) {
            addCriterion("shop_order_productCost =", value, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostNotEqualTo(Long value) {
            addCriterion("shop_order_productCost <>", value, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostGreaterThan(Long value) {
            addCriterion("shop_order_productCost >", value, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostGreaterThanOrEqualTo(Long value) {
            addCriterion("shop_order_productCost >=", value, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostLessThan(Long value) {
            addCriterion("shop_order_productCost <", value, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostLessThanOrEqualTo(Long value) {
            addCriterion("shop_order_productCost <=", value, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostIn(List<Long> values) {
            addCriterion("shop_order_productCost in", values, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostNotIn(List<Long> values) {
            addCriterion("shop_order_productCost not in", values, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostBetween(Long value1, Long value2) {
            addCriterion("shop_order_productCost between", value1, value2, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderProductcostNotBetween(Long value1, Long value2) {
            addCriterion("shop_order_productCost not between", value1, value2, "shopOrderProductcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointIsNull() {
            addCriterion("shop_order_point is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointIsNotNull() {
            addCriterion("shop_order_point is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointEqualTo(Long value) {
            addCriterion("shop_order_point =", value, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointNotEqualTo(Long value) {
            addCriterion("shop_order_point <>", value, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointGreaterThan(Long value) {
            addCriterion("shop_order_point >", value, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointGreaterThanOrEqualTo(Long value) {
            addCriterion("shop_order_point >=", value, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointLessThan(Long value) {
            addCriterion("shop_order_point <", value, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointLessThanOrEqualTo(Long value) {
            addCriterion("shop_order_point <=", value, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointIn(List<Long> values) {
            addCriterion("shop_order_point in", values, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointNotIn(List<Long> values) {
            addCriterion("shop_order_point not in", values, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointBetween(Long value1, Long value2) {
            addCriterion("shop_order_point between", value1, value2, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderPointNotBetween(Long value1, Long value2) {
            addCriterion("shop_order_point not between", value1, value2, "shopOrderPoint");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostIsNull() {
            addCriterion("shop_order_tansportationCost is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostIsNotNull() {
            addCriterion("shop_order_tansportationCost is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostEqualTo(Long value) {
            addCriterion("shop_order_tansportationCost =", value, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostNotEqualTo(Long value) {
            addCriterion("shop_order_tansportationCost <>", value, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostGreaterThan(Long value) {
            addCriterion("shop_order_tansportationCost >", value, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostGreaterThanOrEqualTo(Long value) {
            addCriterion("shop_order_tansportationCost >=", value, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostLessThan(Long value) {
            addCriterion("shop_order_tansportationCost <", value, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostLessThanOrEqualTo(Long value) {
            addCriterion("shop_order_tansportationCost <=", value, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostIn(List<Long> values) {
            addCriterion("shop_order_tansportationCost in", values, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostNotIn(List<Long> values) {
            addCriterion("shop_order_tansportationCost not in", values, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostBetween(Long value1, Long value2) {
            addCriterion("shop_order_tansportationCost between", value1, value2, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderTansportationcostNotBetween(Long value1, Long value2) {
            addCriterion("shop_order_tansportationCost not between", value1, value2, "shopOrderTansportationcost");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodIsNull() {
            addCriterion("shop_order_pay_method is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodIsNotNull() {
            addCriterion("shop_order_pay_method is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodEqualTo(String value) {
            addCriterion("shop_order_pay_method =", value, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodNotEqualTo(String value) {
            addCriterion("shop_order_pay_method <>", value, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodGreaterThan(String value) {
            addCriterion("shop_order_pay_method >", value, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_pay_method >=", value, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodLessThan(String value) {
            addCriterion("shop_order_pay_method <", value, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodLessThanOrEqualTo(String value) {
            addCriterion("shop_order_pay_method <=", value, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodLike(String value) {
            addCriterion("shop_order_pay_method like", value, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodNotLike(String value) {
            addCriterion("shop_order_pay_method not like", value, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodIn(List<String> values) {
            addCriterion("shop_order_pay_method in", values, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodNotIn(List<String> values) {
            addCriterion("shop_order_pay_method not in", values, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodBetween(String value1, String value2) {
            addCriterion("shop_order_pay_method between", value1, value2, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayMethodNotBetween(String value1, String value2) {
            addCriterion("shop_order_pay_method not between", value1, value2, "shopOrderPayMethod");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeIsNull() {
            addCriterion("shop_order_pay_time is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeIsNotNull() {
            addCriterion("shop_order_pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeEqualTo(Date value) {
            addCriterion("shop_order_pay_time =", value, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeNotEqualTo(Date value) {
            addCriterion("shop_order_pay_time <>", value, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeGreaterThan(Date value) {
            addCriterion("shop_order_pay_time >", value, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("shop_order_pay_time >=", value, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeLessThan(Date value) {
            addCriterion("shop_order_pay_time <", value, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("shop_order_pay_time <=", value, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeIn(List<Date> values) {
            addCriterion("shop_order_pay_time in", values, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeNotIn(List<Date> values) {
            addCriterion("shop_order_pay_time not in", values, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeBetween(Date value1, Date value2) {
            addCriterion("shop_order_pay_time between", value1, value2, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("shop_order_pay_time not between", value1, value2, "shopOrderPayTime");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusIsNull() {
            addCriterion("shop_order_status is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusIsNotNull() {
            addCriterion("shop_order_status is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusEqualTo(String value) {
            addCriterion("shop_order_status =", value, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusNotEqualTo(String value) {
            addCriterion("shop_order_status <>", value, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusGreaterThan(String value) {
            addCriterion("shop_order_status >", value, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_status >=", value, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusLessThan(String value) {
            addCriterion("shop_order_status <", value, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusLessThanOrEqualTo(String value) {
            addCriterion("shop_order_status <=", value, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusLike(String value) {
            addCriterion("shop_order_status like", value, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusNotLike(String value) {
            addCriterion("shop_order_status not like", value, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusIn(List<String> values) {
            addCriterion("shop_order_status in", values, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusNotIn(List<String> values) {
            addCriterion("shop_order_status not in", values, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusBetween(String value1, String value2) {
            addCriterion("shop_order_status between", value1, value2, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andShopOrderStatusNotBetween(String value1, String value2) {
            addCriterion("shop_order_status not between", value1, value2, "shopOrderStatus");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Long value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Long value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Long value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Long value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Long value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Long> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Long> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Long value1, Long value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Long value1, Long value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdIsNull() {
            addCriterion("WXuser_id is null");
            return (Criteria) this;
        }

        public Criteria andWxuserIdIsNotNull() {
            addCriterion("WXuser_id is not null");
            return (Criteria) this;
        }

        public Criteria andWxuserIdEqualTo(String value) {
            addCriterion("WXuser_id =", value, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdNotEqualTo(String value) {
            addCriterion("WXuser_id <>", value, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdGreaterThan(String value) {
            addCriterion("WXuser_id >", value, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdGreaterThanOrEqualTo(String value) {
            addCriterion("WXuser_id >=", value, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdLessThan(String value) {
            addCriterion("WXuser_id <", value, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdLessThanOrEqualTo(String value) {
            addCriterion("WXuser_id <=", value, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdLike(String value) {
            addCriterion("WXuser_id like", value, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdNotLike(String value) {
            addCriterion("WXuser_id not like", value, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdIn(List<String> values) {
            addCriterion("WXuser_id in", values, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdNotIn(List<String> values) {
            addCriterion("WXuser_id not in", values, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdBetween(String value1, String value2) {
            addCriterion("WXuser_id between", value1, value2, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andWxuserIdNotBetween(String value1, String value2) {
            addCriterion("WXuser_id not between", value1, value2, "wxuserId");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressIsNull() {
            addCriterion("user_receiving_address is null");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressIsNotNull() {
            addCriterion("user_receiving_address is not null");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressEqualTo(String value) {
            addCriterion("user_receiving_address =", value, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressNotEqualTo(String value) {
            addCriterion("user_receiving_address <>", value, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressGreaterThan(String value) {
            addCriterion("user_receiving_address >", value, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressGreaterThanOrEqualTo(String value) {
            addCriterion("user_receiving_address >=", value, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressLessThan(String value) {
            addCriterion("user_receiving_address <", value, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressLessThanOrEqualTo(String value) {
            addCriterion("user_receiving_address <=", value, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressLike(String value) {
            addCriterion("user_receiving_address like", value, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressNotLike(String value) {
            addCriterion("user_receiving_address not like", value, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressIn(List<String> values) {
            addCriterion("user_receiving_address in", values, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressNotIn(List<String> values) {
            addCriterion("user_receiving_address not in", values, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressBetween(String value1, String value2) {
            addCriterion("user_receiving_address between", value1, value2, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andUserReceivingAddressNotBetween(String value1, String value2) {
            addCriterion("user_receiving_address not between", value1, value2, "userReceivingAddress");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightIsNull() {
            addCriterion("shop_order_totalWeight is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightIsNotNull() {
            addCriterion("shop_order_totalWeight is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightEqualTo(Long value) {
            addCriterion("shop_order_totalWeight =", value, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightNotEqualTo(Long value) {
            addCriterion("shop_order_totalWeight <>", value, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightGreaterThan(Long value) {
            addCriterion("shop_order_totalWeight >", value, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightGreaterThanOrEqualTo(Long value) {
            addCriterion("shop_order_totalWeight >=", value, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightLessThan(Long value) {
            addCriterion("shop_order_totalWeight <", value, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightLessThanOrEqualTo(Long value) {
            addCriterion("shop_order_totalWeight <=", value, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightIn(List<Long> values) {
            addCriterion("shop_order_totalWeight in", values, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightNotIn(List<Long> values) {
            addCriterion("shop_order_totalWeight not in", values, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightBetween(Long value1, Long value2) {
            addCriterion("shop_order_totalWeight between", value1, value2, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderTotalweightNotBetween(Long value1, Long value2) {
            addCriterion("shop_order_totalWeight not between", value1, value2, "shopOrderTotalweight");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidIsNull() {
            addCriterion("shop_order_prePayId is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidIsNotNull() {
            addCriterion("shop_order_prePayId is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidEqualTo(String value) {
            addCriterion("shop_order_prePayId =", value, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidNotEqualTo(String value) {
            addCriterion("shop_order_prePayId <>", value, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidGreaterThan(String value) {
            addCriterion("shop_order_prePayId >", value, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_prePayId >=", value, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidLessThan(String value) {
            addCriterion("shop_order_prePayId <", value, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidLessThanOrEqualTo(String value) {
            addCriterion("shop_order_prePayId <=", value, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidLike(String value) {
            addCriterion("shop_order_prePayId like", value, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidNotLike(String value) {
            addCriterion("shop_order_prePayId not like", value, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidIn(List<String> values) {
            addCriterion("shop_order_prePayId in", values, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidNotIn(List<String> values) {
            addCriterion("shop_order_prePayId not in", values, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidBetween(String value1, String value2) {
            addCriterion("shop_order_prePayId between", value1, value2, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderPrepayidNotBetween(String value1, String value2) {
            addCriterion("shop_order_prePayId not between", value1, value2, "shopOrderPrepayid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridIsNull() {
            addCriterion("shop_order_waterId is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridIsNotNull() {
            addCriterion("shop_order_waterId is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridEqualTo(String value) {
            addCriterion("shop_order_waterId =", value, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridNotEqualTo(String value) {
            addCriterion("shop_order_waterId <>", value, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridGreaterThan(String value) {
            addCriterion("shop_order_waterId >", value, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_waterId >=", value, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridLessThan(String value) {
            addCriterion("shop_order_waterId <", value, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridLessThanOrEqualTo(String value) {
            addCriterion("shop_order_waterId <=", value, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridLike(String value) {
            addCriterion("shop_order_waterId like", value, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridNotLike(String value) {
            addCriterion("shop_order_waterId not like", value, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridIn(List<String> values) {
            addCriterion("shop_order_waterId in", values, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridNotIn(List<String> values) {
            addCriterion("shop_order_waterId not in", values, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridBetween(String value1, String value2) {
            addCriterion("shop_order_waterId between", value1, value2, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderWateridNotBetween(String value1, String value2) {
            addCriterion("shop_order_waterId not between", value1, value2, "shopOrderWaterid");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksIsNull() {
            addCriterion("shop_order_remarks is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksIsNotNull() {
            addCriterion("shop_order_remarks is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksEqualTo(String value) {
            addCriterion("shop_order_remarks =", value, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksNotEqualTo(String value) {
            addCriterion("shop_order_remarks <>", value, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksGreaterThan(String value) {
            addCriterion("shop_order_remarks >", value, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_remarks >=", value, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksLessThan(String value) {
            addCriterion("shop_order_remarks <", value, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksLessThanOrEqualTo(String value) {
            addCriterion("shop_order_remarks <=", value, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksLike(String value) {
            addCriterion("shop_order_remarks like", value, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksNotLike(String value) {
            addCriterion("shop_order_remarks not like", value, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksIn(List<String> values) {
            addCriterion("shop_order_remarks in", values, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksNotIn(List<String> values) {
            addCriterion("shop_order_remarks not in", values, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksBetween(String value1, String value2) {
            addCriterion("shop_order_remarks between", value1, value2, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderRemarksNotBetween(String value1, String value2) {
            addCriterion("shop_order_remarks not between", value1, value2, "shopOrderRemarks");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameIsNull() {
            addCriterion("shop_order_user_name is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameIsNotNull() {
            addCriterion("shop_order_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameEqualTo(String value) {
            addCriterion("shop_order_user_name =", value, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameNotEqualTo(String value) {
            addCriterion("shop_order_user_name <>", value, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameGreaterThan(String value) {
            addCriterion("shop_order_user_name >", value, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_user_name >=", value, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameLessThan(String value) {
            addCriterion("shop_order_user_name <", value, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameLessThanOrEqualTo(String value) {
            addCriterion("shop_order_user_name <=", value, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameLike(String value) {
            addCriterion("shop_order_user_name like", value, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameNotLike(String value) {
            addCriterion("shop_order_user_name not like", value, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameIn(List<String> values) {
            addCriterion("shop_order_user_name in", values, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameNotIn(List<String> values) {
            addCriterion("shop_order_user_name not in", values, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameBetween(String value1, String value2) {
            addCriterion("shop_order_user_name between", value1, value2, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserNameNotBetween(String value1, String value2) {
            addCriterion("shop_order_user_name not between", value1, value2, "shopOrderUserName");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileIsNull() {
            addCriterion("shop_order_user_mobile is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileIsNotNull() {
            addCriterion("shop_order_user_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileEqualTo(String value) {
            addCriterion("shop_order_user_mobile =", value, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileNotEqualTo(String value) {
            addCriterion("shop_order_user_mobile <>", value, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileGreaterThan(String value) {
            addCriterion("shop_order_user_mobile >", value, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_user_mobile >=", value, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileLessThan(String value) {
            addCriterion("shop_order_user_mobile <", value, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileLessThanOrEqualTo(String value) {
            addCriterion("shop_order_user_mobile <=", value, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileLike(String value) {
            addCriterion("shop_order_user_mobile like", value, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileNotLike(String value) {
            addCriterion("shop_order_user_mobile not like", value, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileIn(List<String> values) {
            addCriterion("shop_order_user_mobile in", values, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileNotIn(List<String> values) {
            addCriterion("shop_order_user_mobile not in", values, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileBetween(String value1, String value2) {
            addCriterion("shop_order_user_mobile between", value1, value2, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderUserMobileNotBetween(String value1, String value2) {
            addCriterion("shop_order_user_mobile not between", value1, value2, "shopOrderUserMobile");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateIsNull() {
            addCriterion("shop_order_state is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateIsNotNull() {
            addCriterion("shop_order_state is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateEqualTo(String value) {
            addCriterion("shop_order_state =", value, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateNotEqualTo(String value) {
            addCriterion("shop_order_state <>", value, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateGreaterThan(String value) {
            addCriterion("shop_order_state >", value, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_state >=", value, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateLessThan(String value) {
            addCriterion("shop_order_state <", value, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateLessThanOrEqualTo(String value) {
            addCriterion("shop_order_state <=", value, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateLike(String value) {
            addCriterion("shop_order_state like", value, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateNotLike(String value) {
            addCriterion("shop_order_state not like", value, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateIn(List<String> values) {
            addCriterion("shop_order_state in", values, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateNotIn(List<String> values) {
            addCriterion("shop_order_state not in", values, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateBetween(String value1, String value2) {
            addCriterion("shop_order_state between", value1, value2, "shopOrderState");
            return (Criteria) this;
        }

        public Criteria andShopOrderStateNotBetween(String value1, String value2) {
            addCriterion("shop_order_state not between", value1, value2, "shopOrderState");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}